SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 48757: The bl_bulkload statement examples in the "SAS® Anti-Money Laundering System Administration Guide" contain incorrect syntax

DetailsAboutRate It

The bl_tempload examples in the SAS Anti-Money Laundering System Administration Guide contain incorrect syntax. As shown below, the bulkload options are separated by commas:

bl_tempload=%str(bulkload=yes, bl_load_method=truncate, bl_log=&AMLROOT/logs/get_entity_info.log));

The commas cause a Too many parameters error to the INDEX function (for example, when running the %riskranking macro):

ERROR: Macro function %INDEX has too many arguments.  The excess arguments will be ignored.
BULKLOADTEMP VERSION 4.1
ERROR: AML: RISKRANKING: bl_tempload parameters do not include bl_load_method=truncate

There are two locations in the System Administration Guide documentation where the commas need to be removed (the riskranking and get_entity_info documentation):

p. 37 - 5.2.4.5 Example:

%riskranking (inLib=stg_aler, inDS=combined_alerts, inRiskLib=stg_aler, inRiskDS=risk_factor_alerts, outLib=stg_aler, outDS=ranked_alerts, outRiskLib=mst_aler, outRiskDS=ranked_risk_factor_alerts, riskonly=Y, bl_temp=YES, bl_tempload=%str(bulkload=yes, bl_load_method=truncate, bl_log=&AMLROOT/logs/replicateTransactions.log));

p. 43 5.2.6.5 Example:

%get_entity_info(inLib=STG_ALER, inDS=ranked_alerts, outLib=STG_ALER, outDS=entity_alerts, bl_temp=Yes bl_tempload=%str(bulkload=yes, bl_load_method=truncate, bl_log=&AMLROOT/logs/get_entity_info.log));

The correct syntax is shown below (note the removal of the commas in the %str parameter):

bl_tempload=%str(bulkload=yes bl_load_method=truncate bl_log="&AMLROOT/logs/replicateTransactions.log"));



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money LaunderingSolaris for x644.25.19.2 TS2M39.3 TS1M0
Linux for x644.25.19.2 TS2M39.3 TS1M0
Linux4.25.19.2 TS2M39.3 TS1M0
HP-UX IPF4.25.19.2 TS2M39.3 TS1M0
64-bit Enabled Solaris4.25.19.2 TS2M39.3 TS1M0
64-bit Enabled HP-UX4.25.19.2 TS2M39.3 TS1M0
64-bit Enabled AIX4.25.19.2 TS2M39.3 TS1M0
Windows Vista for x644.25.19.2 TS2M39.3 TS1M0
Windows Vista4.25.19.2 TS2M39.3 TS1M0
Windows 7 Ultimate x644.25.19.2 TS2M39.3 TS1M0
Windows 7 Ultimate 32 bit4.25.19.2 TS2M39.3 TS1M0
Windows 7 Professional x644.25.19.2 TS2M39.3 TS1M0
Windows 7 Professional 32 bit4.25.19.2 TS2M39.3 TS1M0
Windows 7 Home Premium x644.25.19.2 TS2M39.3 TS1M0
Windows 7 Home Premium 32 bit4.25.19.2 TS2M39.3 TS1M0
Windows 7 Enterprise x644.25.19.2 TS2M39.3 TS1M0
Windows 7 Enterprise 32 bit4.25.19.2 TS2M39.3 TS1M0
Microsoft Windows XP Professional4.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2008 for x644.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 20084.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 for x644.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition4.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition4.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition4.25.19.2 TS2M39.3 TS1M0
Microsoft® Windows® for x644.25.19.2 TS2M39.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.